<html>
    <head>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> 
        <title>Nguyen DUy Trung Hieu - c12TDT</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <link rel="stylesheet" type="text/css" href="public/css/style.css"> 
    </head>



    <body>
        <?php
        require_once 'model/db.php';
        ?>

        <h1> Trung Hieu </h1>
        <?php
        $query = "SELECT * FROM companies";
        $companies = getData($query);
        $query = "SELECT * FROM apps";
        $apps = getData($query);
        ?>
        <form method="POST">
            Min <input type="text" name="min_fans" id="min_fans" style="border-color:  #ff33cc" ><br>
            Max <input type="text" name="max_fans"  id="max_fans"  style="border-color: #ccff00"><br>
            Tu Khoa <input type="text" name="keyword" style="border-color: #0000ff"><br>
            Cong Ty<select name="id_company" style="border-color: #00ccff">
                <option value="0">-----company-----</option>
                <?php foreach ($companies as $company): ?>
                    <option value="<?php echo $company['id'] ?>"><?php echo $company['name'] ?></option>
                <?php endforeach; ?>
            </select><br>

            Ung Dung :<select name="id_apps" style="border-color: #ff0000">
                <option value="0">-------App------</option>
                <?php foreach ($apps as $app): ?>
                    <option value="<?php echo $app['id'] ?>"><?php echo $app['name'] ?></option>
                <?php endforeach; ?>
            </select>

            <input type="submit" name="submit" value="Ok">
            <input type="button" name="submit" value="check" id ="check">
        </form>

        <?php if (isset($_POST['submit'])): ?>
            <?php
            $min_fans = $_POST['min_fans']; //TODO
            $max_fans = $_POST['max_fans']; //TODO
            $keyword = $_POST['keyword']; //TODO
            $company = $_POST["id_company"];
            $apps = $_POST["id_apps"];
            if (!empty($company))
                $company = "(companies.id=$company) AND";
            else
                $company = "";
            if (!empty($apps))
                $apps = "(apps.id='$apps') AND";
            else
                $apps = "";



            if (empty($max_fans) && !empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps 
                  (pages.likes>= $min_fans) and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,20";
            } else if (!empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  (pages.likes<= $max_fans) and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,20";
            } else if (empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,20";
            } else {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  (pages.likes>= $min_fans) and
                  (pages.likes<= $max_fans) and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,20";
            }


            var_dump($query);

            $pages = getData($query);
            ?>

            <?php if (!empty($pages)): ?>
                <table id="table" border="1px" style="border-color: #ff9900">
                    <tr class="dien">
                        <td class="profile"> Profile </td>
                        <td class="likes"> Likes </td>
                        <td class="Company"> Company </td>
                        <td class="link"> Link  </td>
                        <td class="website"> website  </td>

                        <td> description </td>

                    </tr>
                    <?php foreach ($pages as $page): ?>
                        <tr>
                            <td><img src="<?php echo $page['picture'] ?>"></td>
                            <td><?php echo $page['likes'] ?></td>
                            <td><?php echo $page['name'] ?></td>
                            <td><a href='<?php echo $page["link"] ?>'><?php echo substr($page["link"], 0, 50) ?></td>
                            <td><a href='<?php echo $page["website"] ?>'><?php echo substr($page["website"], 0, 50) ?></td>
                            <td><?php echo substr($page["description"], 0, 100); ?></td>
                            <?php // var_dump($page);die();?>
                        </tr>
                    <?php endforeach; ?>
                </table> 

            <?php endif; ?>
        <?php endif; ?>

        <script>
            $(document).ready(function() {
                $('#check').click(function() {
                    var min_fans = $("#min_fans").val();

                    //kiem tra so
                    if ($.isNumeric(min_fans)) {
                        alert('Min NUmber');
                    } else {
                        alert(' Min Chưa Có Dữ Liệu');
                    }
                });


                $('#check').click(function() {
                    var max_fans = $("#max_fans").val();


                    if ($.isNumeric(max_fans)) {
                        alert('Max NumBer');
                    } else {
                        alert('Max Chưa Có Dữ Liệu');
                    }
                });
            });
        </script>
    </body>
</html>
